USE [phatphuclocapp]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE sp_HangHoa_Insert 
	@ten nvarchar(80),
	@ma_hang nvarchar(50),
	@ma_nhom_hang int,
	@ghi_chu nvarchar(80),
	@gia_nhap float
AS
BEGIN
	DECLARE @ngay_cap_nhat_cuoi datetime
	SET @ngay_cap_nhat_cuoi = getdate()
	insert into hanghoa values (@ten,@ma_hang,@ma_nhom_hang,@ghi_chu,@gia_nhap,@ngay_cap_nhat_cuoi)
END
GO


